/*
 Navicat Premium Data Transfer

 Source Server         : data
 Source Server Type    : MySQL
 Source Server Version : 50542
 Source Host           : localhost
 Source Database       : mexrap

 Target Server Type    : MySQL
 Target Server Version : 50542
 File Encoding         : utf-8

 Date: 09/20/2015 15:14:23 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `QM_ACTIVE_USER_STATISTICS`
-- ----------------------------
DROP TABLE IF EXISTS `QM_ACTIVE_USER_STATISTICS`;
CREATE TABLE `QM_ACTIVE_USER_STATISTICS` (
  `AU_ID` varchar(255) DEFAULT NULL,
  `AU_NAME` varchar(255) DEFAULT NULL,
  `AU_TYPE` varchar(255) DEFAULT NULL,
  `AU_TIME` varchar(255) DEFAULT NULL,
  `AU_REGION` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `QM_ACTIVE_USER_STATISTICS`
-- ----------------------------
BEGIN;
INSERT INTO `QM_ACTIVE_USER_STATISTICS` VALUES ('1', 'Shireli', 'Web', '05/11/2015 14:19:04', '乌鲁木齐'), ('2', 'user1', 'App', '05/13/2015 14:46:23', '吐鲁番');
COMMIT;

-- ----------------------------
--  Table structure for `QM_DOWNLOAD_USER_STATISTICS`
-- ----------------------------
DROP TABLE IF EXISTS `QM_DOWNLOAD_USER_STATISTICS`;
CREATE TABLE `QM_DOWNLOAD_USER_STATISTICS` (
  `DU_ID` varchar(255) DEFAULT NULL,
  `DU_NAME` varchar(255) DEFAULT NULL,
  `DU_TYPE` varchar(255) DEFAULT NULL,
  `DU_TIME` varchar(255) DEFAULT NULL,
  `DU_REGION` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `QM_DOWNLOAD_USER_STATISTICS`
-- ----------------------------
BEGIN;
INSERT INTO `QM_DOWNLOAD_USER_STATISTICS` VALUES ('1', 'Shireli', 'Web', '05/11/2015 14:18:27', '乌鲁木齐'), ('2', 'user1', 'App', '05/13/2015 14:47:00', '吐鲁番');
COMMIT;

-- ----------------------------
--  Table structure for `QM_PAY_USER_STATISTICS`
-- ----------------------------
DROP TABLE IF EXISTS `QM_PAY_USER_STATISTICS`;
CREATE TABLE `QM_PAY_USER_STATISTICS` (
  `PU_ID` varchar(255) DEFAULT NULL,
  `PU_NAME` varchar(255) DEFAULT NULL,
  `PU_TYPE` varchar(255) DEFAULT NULL,
  `PU_TIME` varchar(255) DEFAULT NULL,
  `PU_REGION` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `QM_PAY_USER_STATISTICS`
-- ----------------------------
BEGIN;
INSERT INTO `QM_PAY_USER_STATISTICS` VALUES ('1', 'Shireli', 'Web', '05/11/2015 14:17:07', '乌鲁木齐'), ('2', 'user1', 'App', '05/13/2015 14:47:20', '吐鲁番');
COMMIT;

-- ----------------------------
--  Table structure for `QM_REGISTER_USER_STATISTICS`
-- ----------------------------
DROP TABLE IF EXISTS `QM_REGISTER_USER_STATISTICS`;
CREATE TABLE `QM_REGISTER_USER_STATISTICS` (
  `RU_ID` varchar(255) DEFAULT NULL,
  `RU_NAME` varchar(255) DEFAULT NULL,
  `RU_TYPE` varchar(255) DEFAULT NULL,
  `RU_TIME` varchar(255) DEFAULT NULL,
  `RU_REGION` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `QM_REGISTER_USER_STATISTICS`
-- ----------------------------
BEGIN;
INSERT INTO `QM_REGISTER_USER_STATISTICS` VALUES ('1', 'Shireli', 'Web', '05/11/2015 00:00:00', '乌鲁木齐'), ('2', 'user1', 'App', '05/13/2015 00:00:00', '吐鲁番'), ('3', 'user2', 'Web', '05/13/2015 00:00:00', '伊犁'), ('4', 'user3', 'Web', '05/14/2015 00:00:00', '乌鲁木齐'), ('5', 'user4', 'App', '05/14/2015 00:00:00', '昌吉'), ('6', 'user5', 'App', '05/14/2015 00:00:00', '乌鲁木齐'), ('7', 'user6', 'Web', '05/14/2015 00:00:00', '和田'), ('8', 'user7', 'App', '05/14/2015 00:00:00', '乌鲁木齐');
COMMIT;

-- ----------------------------
--  Table structure for `mexrap_static`
-- ----------------------------
DROP TABLE IF EXISTS `mexrap_static`;
CREATE TABLE `mexrap_static` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(255) DEFAULT NULL,
  `web` int(12) DEFAULT NULL,
  `app` int(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mexrap_static`
-- ----------------------------
BEGIN;
INSERT INTO `mexrap_static` VALUES ('1', '乌鲁木齐', '15', '84'), ('2', '昌吉', '112', '515'), ('3', '石河子', '515', '26'), ('4', '伊犁', '51', '66'), ('5', '博乐', '51', '94'), ('6', '奎屯', '51', '848'), ('7', '克拉玛依', '515', '51'), ('8', '和田', '51', '32'), ('9', '克州', '59', '61'), ('10', '阿克苏', '95', '61'), ('11', '喀什', '66', '561'), ('12', '阿勒泰', '95', '319'), ('13', '巴州', '984', '87'), ('14', '塔城', '13', '62'), ('15', '哈密', '94', '95'), ('16', '吐鲁番', '894', '95');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
